package com.gxa.mapper.zls;

import com.gxa.pojo.Goods;
import com.gxa.pojo.Goods_Warehouse;
import com.gxa.pojo.Warehouse_Warning;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * Created with IntelliJ IDEA.
 * User: 周林森
 * Date: 2021/12/06 21:26:03
 * Description: 商品SQL
 * Version: V1.0
 */
public interface GoodsMapper {
    //查询商品
    List<Goods> queryGoodsList(Map map);

    //查询商品id是否存在
    String queryGoodsIdExist(Object goods_id);

    //添加商品基本信息
    int addGoodsInfo(Map good);

    //添加库存预警 空
    void addWarehouseWarning(String goods_id);

    //添加期初设置 空
    void addGoodWarehouse(String goods_id);

    //添加库存预警
    int addGoodsWarn(Warehouse_Warning warning);

    //添加期初设置
    int addWarehouse(Goods_Warehouse warehouse);

    //删除商品
    int delGoods(Object goods_id);

    //修改商品状态
    int updateGoodsrStatus(@Param("status") String param,@Param("goods_id") Object goods_id);

    List<Map> queryWarning(@Param("warehouse") String warehouse,@Param("upLow") String upLow,
                           @Param("input") String input,@Param("page") Integer page1,@Param("limit") Integer limit1);

    List<Map> queryWarningCount(@Param("warehouse") String warehouse,@Param("input") String input);

    int updateGoodsInfo(Map map1);
}
